SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304822 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304822 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247432,190081,771802,655922,499861,429748,941508,206608,335812,419638,423573,98030,313739,318334,848518,740037,736407,710165,830535,1041289,684184,985147,122484,329653,148478,728056,665610,457629,57360,469540,495022,414583,114886,453331,909893,241050,59757,55653,231663,620763,220577,436990,968513,111206,635663,182599,680480,653942,134762,45755,829764,205164,315162,860272,653725,204433,295447,392126,99382,277723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]