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` = 437291 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437291 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298163,970958,785136,166937,954351,766198,677829,864443,542340,12389,221555,636215,213354,710622,154989,540030,783504,585201,113153,1009631,141097,761083,155190,100675,476814,465982,331941,606602,163393,123117,353585,1028171,976522,435337,370240,806125,39733,690626,125900,693301,304853,790683,165501,712014,586138,968605,976159,864871,980251,47392,114305,778721,809208,555038,950692,758518,939481,423918,530490,881109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]