SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50589 LIMIT 1 [ RunTime:0.000643s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50589 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492,494959,151147,93625,297196,384215,310696,553329,214329,531995,129450,454428,656366,395241,56405,139157,88158,974433,1009685,468639,273390,1042204,219968,55668,413594,986031,706571,8521,459462,932590,54589,698405,783131,615061,549999,329998,709289,566864,686559,322264,611866,18126,733917,448343,486026,614432,632177,489166,384018,742324,603610,684004,476877,829499,490817,1048079,637636,967462,902059,782421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]