SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195397 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195397 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014171,5843,221538,978504,788705,414559,353391,754526,357173,721873,875656,444637,92805,10841,853495,197309,67771,406045,459968,709819,162056,294757,679500,636272,948812,42611,74880,138957,19770,1034608,678993,129076,103855,980975,97766,924219,461035,748161,595234,993243,593902,826855,713892,61469,546166,35469,1014015,500158,562582,868400,752289,179467,440155,901360,592960,760868,857689,12201,277936,783287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]