SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 16413 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 16413 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525053,835247,667379,34314,890754,399006,318069,515593,32364,688015,612841,129622,74329,460535,804284,804674,529727,414879,511500,1015166,48763,656569,867362,647077,609142,75250,946361,900300,411084,878312,967028,530828,175598,524799,966851,676320,921599,252809,630639,416207,451761,142362,584669,1037246,588258,56690,688768,948310,946950,766354,454796,714508,523703,980116,440230,75107,702460,710623,913195,136917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 16413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 16413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]