SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34388 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34388 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549239,294839,636233,475144,742905,754539,13774,906686,80350,687434,480857,301935,227249,769811,675792,345645,101896,610175,496931,864159,732047,962634,631084,454271,835367,709066,858060,266625,116981,638347,64749,471411,616661,122191,182082,135918,176122,274445,108938,988354,764365,578812,300900,1017565,621260,649995,69842,570791,820981,116612,62155,887316,780700,845361,422963,375034,821397,633444,905482,405584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]