SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034417 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034417 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430697,280262,92835,229032,644278,252342,50345,996109,359366,824582,829515,602769,95190,454281,736327,1033771,929407,711442,93338,780424,816965,701797,1017606,1020496,623976,966208,890417,209074,461913,731940,432288,28143,1015370,227233,218618,258108,363664,582668,476188,279727,501812,1017096,896825,238403,279088,473671,112684,121373,810365,1044386,262197,130761,598364,1023086,583170,233066,740943,304926,925275,480050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]