SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502431 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502431 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125684,593041,920930,276494,342951,374452,692330,637138,124772,386420,443703,694963,645315,112023,110630,947465,691976,947914,490829,590621,303685,451510,10752,638190,94154,437305,403238,1003435,28026,587925,469155,766489,897671,1035444,461910,723144,445422,389046,82327,1048701,138591,407344,443136,73651,790701,854304,124789,648090,408745,198653,455553,1021658,570408,476214,906417,424284,213488,173680,400661,626892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]