SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19481 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19481 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298011,652165,333104,930513,960668,90068,477002,306218,391695,296827,347446,566472,693485,526192,12150,292566,326995,631153,382741,707797,118914,78811,787916,633723,673144,763341,267301,458085,192783,88538,480910,408323,1026621,18317,133693,180548,143876,196521,723430,232778,939327,339441,480952,886633,115919,532356,126464,368111,301272,330549,565892,108357,564970,907050,1031066,309569,882407,374635,953961,308132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]