SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046148 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046148 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568627,372762,366424,856709,552331,550199,156238,835567,210409,848744,90413,61710,490760,684632,195977,427916,635038,43652,253116,632521,897368,549734,825410,583997,116532,633905,959181,136168,999429,197854,508618,336600,558963,738262,61105,432092,482310,393830,763059,1022850,139156,687253,685964,72632,803021,347151,646952,15915,184763,25434,14348,772564,544620,909025,913757,321068,154369,297516,268713,350145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]