SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 657823 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 657823 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100380,1019647,894198,140237,430411,155472,802176,142681,677342,567398,1048225,928382,572383,971029,594137,36062,147623,1016187,1003801,85084,73979,62215,237207,34648,356440,1024876,229917,984390,1047806,463895,457088,775612,181186,417051,654138,30545,557697,770714,722933,920397,249615,1028531,30504,510906,1039911,1005385,55139,899308,797777,88652,548175,1032557,371021,587159,980932,283705,345497,243204,797073,464563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 657823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 657823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001192s ]