SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508860 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508860 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331739,285302,731611,491890,755529,1043203,127210,420071,724397,107858,733331,639963,431383,908700,1374,745059,346390,159386,829177,915039,13227,417060,631774,55220,502890,203487,895875,851232,383218,568255,594342,544850,703087,758655,899160,97835,239520,738744,806266,189318,478748,712641,645332,318750,142537,1033317,302809,280197,843304,328167,334115,251910,830101,322644,16981,490927,1016875,412088,435785,963172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]