SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544514 LIMIT 1 [ RunTime:0.000596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544514 [ RunTime:0.005173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536802,980815,731085,255824,511769,296526,234333,109949,461673,324590,260168,644982,916291,386122,244908,985284,517985,893032,129614,1006783,187138,214604,994755,437377,323986,834014,693757,387038,663162,387529,796439,525013,932741,878720,165613,274721,38866,952907,695864,345620,456895,538563,42632,897032,78237,498598,295240,1036438,516054,920931,962385,709751,281102,391521,410116,644122,366455,1048690,734151,175971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]