SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538506 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538506 [ RunTime:0.004415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450156,427936,590948,768453,868303,191710,390624,430590,779163,410162,386775,863373,139755,276114,530311,620818,66334,419045,373272,985450,430070,507705,218629,606834,484215,397458,983414,860783,287966,730303,336888,535404,763446,976056,927495,329997,650265,461502,174633,1019657,571448,218587,982234,625346,29354,350278,768133,532517,340668,293217,324198,54088,237247,631130,784114,273294,100613,842544,553171,194618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]