SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434765 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434765 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971008,813583,1025480,292760,326033,88603,987216,507502,979393,473430,159813,1018255,771895,79116,700001,358773,269696,770938,43708,516591,329405,599297,509462,180360,17187,441890,4033,279332,454612,522060,124356,25985,570002,901150,843115,106538,521451,46430,169568,670010,126512,334504,987744,822901,351167,886044,299615,511165,108569,976927,67977,239124,950946,991343,372001,566590,225048,790056,548007,757291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]