SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504663 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504663 [ RunTime:0.005616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035535,798435,475025,1019992,430047,811011,820149,419627,473993,490488,788670,677804,631950,212480,449087,141311,506877,638674,431344,666271,305020,996504,1034560,818984,927245,360786,264411,304129,825215,907327,646980,504818,26417,507828,145605,941619,501577,478147,243370,298596,438439,329976,471360,923583,582141,575170,339594,858794,230577,401440,86245,179424,990010,52309,398109,774448,650998,934759,1034012,415674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]