SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526411 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526411 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269730,1000066,182245,880687,671106,612961,288720,953832,88308,923364,963867,19295,937663,77965,360611,596220,942142,434469,797262,317546,204277,205627,185441,59744,274,134084,209248,612152,298888,462231,407480,101456,953368,542436,600050,270192,750254,493419,534605,429200,773951,742581,583123,671923,6920,896331,386063,664528,777611,266367,828615,827592,150104,644524,581501,89531,887689,884586,57363,855700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]