SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403437 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403437 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389563,1038740,846733,109287,70530,492543,957713,546905,118341,614854,647540,228285,108955,457481,986644,191606,870711,1029278,203824,50491,129820,922125,1004497,174930,961475,10417,845704,946709,294518,350872,501294,225521,69669,1026340,383502,928152,751288,663526,334099,724127,671350,439603,498776,540951,453050,803157,91548,216772,753643,1032865,964299,962993,589482,191452,212469,460407,890923,66237,349782,728274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]