SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003788s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410023 LIMIT 1 [ RunTime:0.001781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410023 [ RunTime:0.002591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286603,273278,605511,609473,95678,842441,620040,836715,658311,999720,330437,739257,920780,722599,344878,350496,55701,144383,160252,93304,451451,890420,699133,512774,506571,174570,704120,542813,650746,867537,431897,789365,17530,679171,587969,794266,761707,639603,399309,889659,651821,385413,649402,62009,747755,900369,717926,666899,210739,1034193,750749,570556,363479,966806,692594,976849,679479,985319,47119,65253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]