SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394309 LIMIT 1 [ RunTime:0.000587s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394309 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408281,283474,978067,767743,585520,760055,42886,749994,18663,835320,269332,1014200,230807,205497,418342,241969,195414,754636,1037413,785322,386832,893014,871595,1004246,123610,255803,762994,769432,944762,488539,1039573,543849,683876,843333,1016580,260430,448064,544713,626891,925628,554502,517598,341308,786709,949831,169754,831840,46669,1018398,336423,655481,497517,234346,307314,199493,285034,370323,780167,565380,234252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]