SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544184 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544184 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443488,998773,456627,414088,412157,937092,120140,985497,579477,432173,198898,176929,1000877,1008160,981668,336342,905652,13094,62221,638701,350486,822498,938364,792894,628679,866667,757443,502002,933684,462115,28658,622972,968196,247670,696007,859817,1025135,512587,963031,151229,1004643,107446,748323,829036,1007844,208070,365465,402700,383409,652253,496700,372786,588813,498721,716332,323779,75846,719264,561298,205174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]