SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020033 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020033 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623323,772599,868728,51879,968103,820578,345779,585572,458725,906708,711898,551297,565249,472611,170551,434517,549966,803177,709263,939178,581151,374914,164195,985279,359811,586082,764205,822498,10518,692516,51203,530665,317350,458668,30459,266594,331059,763769,43509,799947,278748,845476,554062,944287,674213,504078,138326,83545,12460,602646,595291,1045423,430917,554674,252900,14761,514528,764238,1023722,411130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]