SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484580 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484580 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317065,854134,972355,714197,824157,938498,526508,374179,391939,1045360,983890,326226,159585,217523,553719,1024352,104619,643859,1016522,36016,334295,1020584,83141,624443,876547,194671,409385,661563,941399,372827,884929,10790,196997,978413,832984,751893,979549,72090,1041362,96109,805686,799766,502721,572919,912988,227333,447735,661013,350082,968862,153856,260682,799071,350464,776707,974748,952140,385094,265295,98783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001334s ]