SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310245 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310245 [ RunTime:0.004980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714518,141699,1017980,308986,785927,3341,39344,442925,205886,531096,213158,1019682,250998,137381,1013217,978860,73612,854440,967966,665999,8453,494853,845377,593216,154552,418483,336443,759033,732027,403736,154621,232463,218584,586308,187410,444384,41752,521022,296013,113253,147551,163218,739483,199786,315652,596596,61890,206932,377620,819307,220333,1047957,41257,1030008,712121,115334,588390,776525,529686,671794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]