SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476698 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476698 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017775,1025122,624469,361543,971539,384003,225105,671568,301701,181542,49588,615931,682738,295508,213916,878474,278607,112914,28112,585328,161060,600188,577671,149630,1019180,866127,575547,244715,28950,593818,756532,1035295,434734,894570,597673,670817,948826,554219,352567,247586,541802,420976,249244,6961,676493,314681,940314,1035040,120062,689303,482469,828383,593996,424925,243055,92715,710870,564809,673603,581338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]