SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241990 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241990 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114201,114294,94136,642860,996118,128430,820767,810202,870857,756630,336490,655172,169346,838207,1037024,68774,730911,820699,98710,996559,565234,592604,657914,1020758,742974,600581,670961,880371,538956,510279,942337,199554,894435,971821,959841,872303,870074,419600,746767,180444,782966,521024,921164,537590,530627,840442,217686,393421,917606,343791,990885,209557,184329,524038,257463,18797,1041165,838969,301926,1014229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]