SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261422 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261422 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398117,55589,704363,502368,557821,402294,230622,106224,487688,416038,443839,640328,718799,333917,967527,549175,351574,991426,564261,1012375,838381,302583,23702,89926,382094,675169,840201,402018,317879,777080,308344,168276,297569,436009,338045,71874,616875,402531,724418,667354,45539,714661,539585,161916,887779,538173,1012778,685440,800389,6626,308326,461108,256977,1011225,791536,801984,694963,359996,1039187,564686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]