SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532627 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532627 [ RunTime:0.003700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197418,1000182,471899,730910,980293,637968,1015343,734080,621352,202452,777460,696419,214756,867284,753824,465214,51362,151351,138581,936762,792518,618545,644117,164626,187555,543368,916331,181399,286758,61026,714187,152178,155874,497510,475162,958955,22920,264193,667766,1041720,236732,558761,142375,195842,601043,439224,14746,565989,182809,689177,486365,235157,45717,837504,446563,439503,428614,894111,221762,1008138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001540s ]