SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476457 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476457 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999447,549950,517309,128344,354047,971866,511958,1001968,182656,968964,240627,868506,408782,341943,256713,411085,1026836,1000977,1015709,503358,378662,129822,270824,847831,848326,833617,64836,657277,1024439,957729,309332,512482,878433,765628,444769,623695,817053,410012,278182,802696,858673,958998,385335,110958,557802,654680,1040982,321904,726467,533237,131545,399106,523070,526136,530638,781674,83972,855327,74454,569726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]