SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023328 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023328 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24704,807594,549354,965111,1008105,467522,1021908,306658,983817,882161,36074,551828,426930,765458,72630,527779,392751,455279,35859,350450,206995,1021892,372380,148938,435525,729923,103550,3054,69037,84650,370809,692726,655925,520962,27500,858564,233458,441829,652209,832638,454203,789614,844720,671623,603650,360842,677157,460394,605844,870442,530826,741433,172689,681794,748289,1009470,907885,771774,35344,690402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]