SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500751 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500751 [ RunTime:0.004412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494715,423598,413551,359436,764344,334461,410555,508354,951403,138754,866506,889931,672579,1029701,289000,63000,475703,667640,681043,39946,138714,89997,579591,604386,250798,896068,220442,310465,896836,620318,125012,1027026,140838,201971,242709,396612,860804,270416,387328,393823,842173,775109,586074,600052,43525,780002,512547,563080,226831,131748,725565,204956,194135,8780,961281,363487,526693,601568,977936,576895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001062s ]