SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560617 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560617 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285171,860662,653714,230975,509329,29540,127617,628620,851127,83305,432386,83880,229715,529172,401247,71815,468579,437329,1028202,32135,1034662,698180,698333,779937,855798,661731,672454,188471,611902,154203,425517,853175,530172,874674,206198,576667,742890,434434,355498,446634,930547,701012,807731,6902,895341,368319,612031,231701,754839,499083,742464,299165,951656,593731,394780,810579,127173,346637,471011,800382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003051s ]