SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010684 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010684 [ RunTime:0.002900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148250,172763,495817,996522,976503,540704,869921,407441,1046020,444811,776167,53038,200432,661497,288909,72149,819526,723416,593861,631946,1001747,933814,156544,545594,653908,116174,214740,838115,51238,778999,440944,104227,501402,892447,986491,44321,865995,892969,323683,59626,568333,305551,116549,373794,827411,277659,918650,354167,218133,227482,486028,304111,460345,942220,170571,964229,205157,717988,435256,1041681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]