SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354452 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354452 [ RunTime:0.006746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173476,968671,493497,868859,539218,913778,969263,812370,822866,982297,819756,195599,329623,124987,33763,708939,592629,506776,134752,663515,1029858,195654,884581,287672,151040,886153,161973,675760,1003230,471316,752245,151512,253751,639517,137870,443418,163980,1028811,489041,707522,832621,108329,128531,755984,335444,834506,594092,926804,702374,320705,658273,298736,596641,37701,794841,439867,21804,803031,205574,1012623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]