SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41875 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41875 [ RunTime:0.003937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334918,664121,912892,653007,370929,551343,360974,1000713,1019346,813228,314798,48234,842912,1030457,951635,340978,584465,792201,613405,118318,391745,785992,423017,268709,4499,521185,14960,684933,760335,681505,714192,545414,634778,635475,993305,1017527,392644,304581,934571,35314,354457,366869,478722,274966,437680,1034892,803078,600943,379347,319972,646815,454855,199942,941636,732574,638544,316329,208501,677491,887092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]