SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020662 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020662 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777013,29605,762672,158163,102729,143917,593460,964394,65467,1030855,564400,51420,282565,653054,437406,335361,528755,826974,174982,335575,463250,307143,1038110,89248,406622,31156,667030,428417,522245,372225,1028494,312643,526007,344134,358177,1020336,706783,799818,517843,41761,353579,633540,739650,198718,338160,888768,59339,423959,597498,6765,890568,984261,284438,963196,346281,544954,551123,761108,488544,277607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]