SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101182 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101182 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150547,695675,632051,449055,468813,920966,479084,818560,319060,744746,1032312,718916,298623,937263,610266,928906,373698,189281,962691,190750,22280,342697,755522,123897,504892,325427,655326,129543,800489,851776,933315,203044,866516,222803,1007390,431255,223258,774596,171941,925140,979307,28933,237974,605177,204854,248347,69117,897814,1001195,995882,934896,809758,351352,228416,967267,811491,53629,670274,897234,550501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]