SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44320 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44320 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134903,138391,457445,308681,562036,615941,9672,74973,644598,123730,290485,693323,317461,321682,193329,651321,592413,907210,969539,884549,107173,272327,672659,951622,780461,1038844,603453,3601,332679,831756,198154,922851,499727,214348,378102,678974,444968,706865,409224,383245,101918,596916,921732,250148,98851,208364,966855,889483,899912,155206,1001464,468917,46420,20736,144136,232625,1048373,1025908,159537,698904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]