SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517510 LIMIT 1 [ RunTime:0.001166s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517510 [ RunTime:0.002462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022119,340124,640026,686801,913198,240252,922200,450086,444055,55024,146775,892781,709604,686287,309531,610324,366489,257587,263369,914995,699256,474905,973927,423963,50800,487219,614565,15481,190650,294330,372412,100119,786668,418307,680674,7012,1004331,767093,539073,508697,844016,220016,466425,737200,563307,311007,767384,887699,670996,97899,1033616,731062,920802,267720,713138,319149,644305,1033012,819563,339869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]