SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432501 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432501 [ RunTime:0.003664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858840,843431,604605,324779,544043,301260,268960,434758,207404,529225,536883,714785,421906,307965,971099,861190,792930,941919,818028,1025867,308607,784073,686957,324624,247198,1017314,946548,865560,27776,146524,642190,871718,641699,411075,249712,530161,308403,293675,76763,510580,416320,751557,183897,844640,10287,741381,169937,511734,327405,276354,1012803,185454,448466,621543,647370,909175,302138,320026,74413,354768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]