SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029684 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029684 [ RunTime:0.003353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611244,303367,3893,413576,474346,689786,435368,998835,348070,12034,817732,503713,649996,374666,784348,413335,771529,727893,165748,635351,974263,869988,810391,672488,407006,427547,771125,118445,162609,655986,320797,249424,317896,406956,656621,224311,647623,232521,346789,344892,336954,599936,458857,94755,790445,112202,339491,750683,810508,294958,616409,503813,159465,521283,235054,80855,511048,92870,704135,98440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002107s ]