SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016540 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016540 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234875,630913,726179,591792,864520,845779,429288,746309,265496,835425,129472,790099,359240,220936,124187,214042,514769,501862,867390,5203,763596,195551,136590,652176,225054,877967,9371,587830,253486,382298,9831,762514,620964,873961,165713,576112,405405,749362,301443,579318,352488,5464,133115,606851,216099,179673,142057,159809,422800,360021,702962,310687,354754,60667,217610,299717,589170,584597,896455,51387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]