SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531607 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531607 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147413,734966,402517,860028,904254,430203,814171,837001,709258,499453,59784,155539,388475,1009057,678326,453514,824332,626219,677927,943020,168414,741005,299660,35092,854488,984901,259976,415704,466752,597331,288322,1017001,297690,549300,1023443,876331,310348,934709,130894,498296,904046,284724,888619,754378,601323,410032,499448,685558,734935,176291,11389,80774,717873,519478,824386,387046,138947,495152,909169,1047371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]