SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003891 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003891 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832114,944580,698142,194274,750896,289779,694025,15576,67566,325630,455234,1035758,939381,753878,767488,296915,307939,205078,236960,658336,187593,263847,696200,1003801,498448,900762,531542,10401,953295,502081,268155,1042198,118466,816809,585979,686613,497396,494275,299823,907038,722883,470194,530168,201843,93375,790617,869951,799408,187152,394229,169366,583046,1028497,789046,551281,542627,308429,69554,227845,555089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]