SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5042 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5042 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294783,378347,193467,820723,58231,280342,306574,213347,19846,903642,760742,800800,588460,270686,291440,391771,262006,963959,108995,860232,1036140,710963,127388,666036,1000867,939597,546805,905026,980666,240554,410213,1035306,881242,3598,138633,186531,238287,357581,11836,682318,221876,225848,21334,936641,698961,808159,624581,533272,714897,493524,10472,691538,1010409,950341,789664,85872,504789,636887,985084,1028866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]