SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804998 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804998 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43505,787551,997353,968487,799758,471810,182044,225280,892231,489864,374106,617736,737471,745893,877175,322686,161224,581678,667349,488265,851126,452554,1021308,868803,415087,51116,809222,1025913,972023,73874,426166,534641,331389,598525,1027076,635700,922547,723959,609076,348636,325608,464850,36988,61832,176908,287987,358966,300707,1045101,849677,644004,763237,642406,391495,44789,801802,459356,276120,635789,320960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]