SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529613 LIMIT 1 [ RunTime:0.002210s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529613 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217366,411942,671687,172676,483154,159444,922219,889143,683474,962930,24581,527911,950234,1035927,576523,470093,764101,422403,1003778,862307,632720,754438,36899,991959,42790,854988,130901,994207,775299,807560,447085,408321,544431,154022,790480,803082,293062,262317,192318,767194,621349,547848,268598,614785,491401,539922,277871,200882,25576,540729,942475,766008,33795,640410,488589,110450,399580,131483,762509,372369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001721s ]