SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598984 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598984 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296275,461537,905578,388473,604409,787011,910835,247859,448149,924906,106685,543726,57450,569458,390048,514307,846771,146908,652909,772587,807240,986671,137387,297657,238475,87302,717052,128791,754961,240546,7014,20140,628691,218294,680604,240188,317827,25509,854686,857582,452325,53688,208053,855564,301908,758722,869453,528136,624006,765100,698374,1003508,826604,411446,167501,956312,946884,912771,50793,14536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]