SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595455 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595455 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540148,1024807,1003793,563226,179774,31403,241845,361674,778061,573763,698061,453238,295335,570837,509662,562268,406464,1024930,1035189,914032,372043,177002,237646,685088,280151,819512,757406,21526,779272,413002,673673,697104,604463,399247,1011103,875169,228920,875048,132096,174140,45550,921000,970154,927874,688415,198085,195035,965537,793798,749807,320269,56254,46251,304321,108958,192464,892665,221016,227664,876013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]