SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562889 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562889 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944410,118766,4413,425323,1009946,817340,572914,192669,554480,521062,210867,304552,523123,1047514,349739,14562,550101,1014707,339282,224530,705639,283914,258086,681713,1037029,57230,156508,754664,217955,15905,121202,751103,601742,104886,416263,964296,1026590,431962,159534,509083,330094,393923,262567,109835,300654,647942,941971,777996,56748,89455,674249,820761,778191,206992,775247,473854,425544,906456,20325,605362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]