SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555423 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555423 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6329,251792,39637,857370,486166,1001999,239867,265857,579630,952152,758325,704031,327818,313245,298127,323181,613195,350582,968359,844421,49899,115810,1032317,495241,512206,891544,156743,575596,891263,61039,12042,741227,858476,890849,705080,727369,42105,107855,1036058,200513,496943,233878,712254,113124,883324,904440,502671,111547,173880,797050,754020,397919,309485,559359,292519,992233,30651,179370,239514,620480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002334s ]