SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981807 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981807 [ RunTime:0.005422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743941,572969,1046152,59825,359282,740457,634053,100729,573535,330234,797956,914708,541090,64387,263404,717926,72200,293576,215760,1034216,493441,638281,758369,727252,432811,661224,1016966,975268,742438,464620,339515,1022025,129813,651984,732618,779204,791604,11724,36817,709564,696721,129555,88533,1018389,729881,135337,892547,487929,37532,569895,977473,675493,952672,396071,76501,166243,512938,1033018,713793,510375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]