SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320423 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320423 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451786,112941,561463,225474,489304,581129,1005345,605321,424286,165939,9495,445258,457772,970709,527815,359377,1036879,336552,859724,210635,918821,206286,701202,410660,160534,758188,626285,309504,340374,783336,214389,667727,622780,569262,352580,770492,843165,739100,289613,547820,282200,463173,1035613,422098,608484,726582,539581,294704,918903,304026,549402,745715,492083,451692,259467,672186,913250,687893,518768,813839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]