SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014109 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014109 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18757,463494,871467,748452,744507,893936,690444,538654,104793,1022286,4648,361513,934750,867618,19940,260701,988759,261069,365184,109007,670308,1045399,824530,232714,735970,1014552,520186,644451,523499,110806,589266,953932,74900,472485,668133,341960,577137,600614,184105,495840,174787,344889,460617,896918,711811,653114,143896,833518,967075,386006,129639,525918,1017073,946148,900007,709052,340061,86890,591487,399185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]