SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580512 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580512 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803614,67747,125716,342586,701025,103024,627358,594943,1043496,553538,3648,516122,125548,726040,213242,479751,677261,920756,341765,125989,980179,390683,715681,197898,308386,840104,395607,592697,647071,192306,347074,944879,660726,775105,174567,152052,910441,519972,649401,958592,389504,573115,19114,367393,38120,503250,939068,207712,32783,920268,25457,860996,309489,381835,227976,401666,479137,883485,328124,230141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]