SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100324 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100324 [ RunTime:0.002828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008376,421088,358113,231938,957264,101553,470180,857020,464290,14161,388080,605559,712917,950390,49661,155994,816689,348807,409589,1044661,996653,764038,773312,843030,735893,427558,306689,717392,254598,429504,909227,711300,399472,441614,172873,515598,296791,92493,292796,1003976,55827,1032064,840521,162257,460983,963246,418209,493723,61103,489798,837557,675320,572963,482929,156480,10990,56159,697943,122258,757413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]