SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527580 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527580 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517513,912728,830161,281729,169854,849661,461981,698861,643042,207606,649920,904321,495059,700836,590364,197830,525398,648281,803220,837679,974931,130327,828657,1039768,606539,1009255,944958,980181,918589,493759,835809,929461,214937,976070,447450,31850,583689,101521,391434,612999,894007,754892,15870,783205,445027,52889,623860,12866,195133,1041881,931173,928121,993289,263539,1018931,696445,1041456,1025612,8679,509987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]